Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

PostgreSQL
1) Aggregate Functions
2) Analytical Functions
3) Array
4) Constraints
5) Cursor
6) Data Type
7) Database
8) Date Timezone
9) Index
10) Inheritance
11) Insert Delete Update
12) Math Functions
13) Postgre SQL
14) Select Query
15) Sequence
16) Store Procedure Function
17) String Functions
18) Subquery
19) Table
20) Table Joins
21) Transaction
22) User Previliege
23) View

Postgre SQL
1) Assign two variables in select into clause
2) Assign value to variable using select into
3) Assigning a concatenated value to a string
4) Command can be used to view all sequences in the currently connected database
5) Concatenating strings
6) Configuration Settings Functions
7) Create a subblock
8) Create data type
9) Create data type and use it as a column data type
10) Create Language plpgsql
11) Current_schemas(false)
12) Declaration of Composite Types
13) Declare local variable
14) Decode binary string from string previously encoded with encode
15) Default value assignment
16) Define and use record type
17) Delete data in a function
18) Displays all data types in the connected database, with comments
19) Displays all database objects in the connected database, with comments
20) Displays all database objects, with comments
21) Displays all databases available, with comments
22) Displays all functions in the connected database, with comments
23) Displays all indices in the connected database, with comments
24) Displays all operators in the connected database, with comments
25) Displays all sequences in the connected database, with comments
26) Displays all tables in the connected database, with comments
27) Displays all views in the connected database, with comments
28) Function for log
29) Generate_series demo
30) Generate_series(0,14,7)
31) Generate_series(4,3)
32) Generate_series(5,1,-2)
33) Inet address of the local connection
34) Inet address of the remote connection
35) Insert data to a log table
36) Joined words
37) Listing psql slash commands
38) Multiline comments
39) Name of current database
40) Name of current schema
41) Names of schemas in search path optionally including implicit schemas
42) Nested for loop
43) Plpgsql is case insensitive
44) Port of the local connection
45) Port of the remote connection
46) Querying a system table
47) Reading from a file into a variable
48) Recovering from the abort state
49) Row function with defined data type
50) ROWTYPE assign through select into
51) SELECT abc def
52) SELECT version()
53) Set_config(log_statement_stats, off, false)
54) Simple While LOOP
55) Single-line comments
56) SQL Functions Returning Sets
57) String Concatenation Operator Type Resolution
58) The variable list
59) Timestamp with time zone postmaster start time
60) To get out of psql
61) Two anyelement parameters
62) Update table data through function parameters
63) Using a variable in an INSERT
64) Using function to insert data to a table
65) Using interpolation during an INSERT
66) Using operators with NULL values
67) Using RAISE EXCEPTION
68) Using RAISE NOTICE
69) Using SELECT INTO with multiple columns
70) Using select into to set variable value
71) Using the %ROWTYPE attribute
72) Using the %TYPE attribute
73) Using the basic loop
74) Using the FOR loop with %ROWTYPE
75) Using the IFTHENELSE statement
76) Using the RAISE statement
77) Using the SELECT INTO statement
78) Using the WHILE loop
79) Using variable declaration options
80) VACUUM command
81) Variable Declarations